package com.gao.frame.study.shop.config.module.domain;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import java.math.BigDecimal;
import java.util.Date;
import lombok.Data;

@Data
@TableName(value = "warehouse_proudct")
public class WarehouseProudct {
    /**
     * 商品库存ID
     */
     @TableId(value = "wp_id", type = IdType.AUTO)
    private Integer wpId;

    /**
     * 商品id
     */
    @TableField(value = "product_id")
    private Integer productId;

    /**
     * 仓库ID
     */
    @TableField(value = "w_id")
    private Short wId;

    /**
     * 当前商品数量
     */
    @TableField(value = "currnet_cnt")
    private Integer currnetCnt;

    /**
     * 当前占用数据
     */
    @TableField(value = "lock_cnt")
    private Integer lockCnt;

    /**
     * 在途数据
     */
    @TableField(value = "in_transit_cnt")
    private Integer inTransitCnt;

    /**
     * 移动加权成本
     */
    @TableField(value = "average_cost")
    private BigDecimal averageCost;

    /**
     * 最后修改时间
     */
    @TableField(value = "modified_time")
    private Date modifiedTime;

    public static final String COL_PRODUCT_ID = "product_id";

    public static final String COL_W_ID = "w_id";

    public static final String COL_CURRNET_CNT = "currnet_cnt";

    public static final String COL_LOCK_CNT = "lock_cnt";

    public static final String COL_IN_TRANSIT_CNT = "in_transit_cnt";

    public static final String COL_AVERAGE_COST = "average_cost";

    public static final String COL_MODIFIED_TIME = "modified_time";
}